package com.yongjie.springbootlogin.mapper;

import com.yongjie.springbootlogin.entity.Notice;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface NoticeMapper {
    //查询所有公告
    List<Notice> allList(Notice notice);



    //查询总条数
    Integer selCount();
    //获取分页数据
    List<Notice> getUsersPages(@Param("currentPage" ) int currentPage,@Param("pageSize" )int pageSize);


    //添加数据
    public int insNotice(@Param("title")String title,
                         @Param("content")String content,
                         @Param("n_user")String n_user,
                         @Param("classify")String classify,
                         @Param("nt_state")String nt_state);


    //删除数据
    public Integer delnotice(Integer id);

    //根据id查询公告
    Notice finnoticeById(int id);



}

